﻿using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//Please add references
namespace Maticsoft.DAL
{
	/// <summary>
	/// 数据访问类:Oitems
	/// </summary>
	public partial class Oitems
	{
		public DataSet GetListV(string strWhere)
        {
            string strSql = "select Oitems.*,Books.CategoryId,Books.Pic from Oitems left join Books on Oitems.BookId=Books.BookId";
            if (strWhere != "")
            {
                strSql += " where " + strWhere;
            }

            return DbHelperSQL.Query(strSql);
        }
	}
}

